﻿
create database Student
on(
    name ' Student'
    filename='D:\ps\SQL安装包\MSSQL12.MSSQLSERVER\MSSQL\DATA\',
    size = 5mb,
	maxsize =50mb,
	filegrowth=10mb


)
log on 
(
   name ' Student'
    filename='D:\ps\SQL安装包\MSSQL12.MSSQLSERVER\MSSQL\DATA\',
    size = 5mb,
	maxsize =50mb,
	filegrowth=10mb

)
go
use Student

go
create table Stuinfo
    StuID int primary key identity(1,1)not null,
	StuNum Nchar(10) not null,
	StuName nvarchar(20) not null,
	StuSex char(1) default('') check(StuSex='' and StuSex='Ů') not null,
	StuPhone char(11) not null 

go
creat3 table ClassInfo
go

lassID int primary key identity(1,1)not null,
	ClassNum nvarchar(15) not null,
	ClassName nvarchar(30)not null,
	ClassRemark text not null,
	StuID int not null



